CREATE EXTERNAL TABLE IF NOT EXISTS spmi_ods.spmi_capacity_fine(
id                                                 bigint                         COMMENT '主键ID',
reasons                                            String                         COMMENT '罚款原因',
amount                                             Double                         COMMENT '罚款金额',
type                                               String                         COMMENT '罚款类型',
task_no                                            String                         COMMENT '任务单号',
carrier_name                                       String                         COMMENT '承运商',
carrier_id                                         bigint                         COMMENT '承运商ID',
bill_month                                         String                         COMMENT '账单月份',
create_time                                        timestamp                      COMMENT '创建时间',
create_by                                          bigint                         COMMENT '创建人ID',
create_by_name                                     String                         COMMENT '创建人名称'
)
COMMENT '运力罚款表'
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/spmi_ods.db/external/spmi_capacity_fine'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);
